package dashboard.constant;

public class IncomeNetflowCateConst {

    /* 类别各产品趋势图查询 */
	private static final String PATTEN_CatePro = "cate_name='%s' AND business_name='%s' AND stat_type='%s'";
	public static String getCateProCol(String dateGroup, String index) {
	    return dateGroup+","+index+",product_type";
	}
	
	public static String getCateProCon(String stat_type, String businessName, String cateName){
	    return String.format(PATTEN_CatePro, cateName, businessName, stat_type);
	}
	
	
	private static final String CON_CateCmp = "cate_name in('%s','%s') AND business_name='%s' AND product_type='%s' AND stat_type='%s'";
	private static final String COL_CateCmp = "%s,cate_name,%s";
	/**
	 * 类别对比查询列，查询条件
	 * @param dateGroup
	 * @return
	 */
	public static String getCateCmpCol(String dateGroup, String index){
	    return String.format(COL_CateCmp, dateGroup,index);
	}
	
	public static String getCateCmpCon(String stat_type, String businessName,String proType, String cate1,String cate2){
	    return String.format(CON_CateCmp, cate1,cate2, businessName,proType, stat_type);
	}
}
